# 创建数据库连接
import pymysql

db_conn = pymysql.connect(host="81.68.81.180", port=3306, user="webgis", passwd="webgis", db="webgis",
                          charset="utf8")
# 获取一个游标对象
cursor = db_conn.cursor()
# 执行数据库插入操作
cursor.execute('insert into identifyresult(recognition_input,recognition_out,data_number) values (1,1,1)')
# 提交
db_conn.commit()
# 关闭连接
db_conn.close()
cursor.close()
